<%@ Page Language="C#" AutoEventWireup="true" StylesheetTheme="YUI" Theme="YUI" CodeFile="DataCleansing.aspx.cs"
    Inherits="Home_DataCleansing" %>

<%@ Register Src="../UserControls/Menu.ascx" TagName="Menu" TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Placement Manager: Data Cleansing</title>
</head>
<body>
    <form id="form1" runat="server">
        <div id="doc3" class="yui-t7">
            <div id="hd">
                <uc1:Menu ID="Menu1" runat="server" />
            </div>
            <div id="bd">
                <h1>
                    Data Cleansing</h1>
                  <div class="yui-g">
                <div class="yui-u first">
                    The following Venues do not have an address.<br />
                    <asp:GridView ID="gvVenuesWithoutAddresses" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" DataSourceID="odsVenuesWithoutAddresses" SkinID="Results">
                        <Columns>
                            <asp:BoundField DataField="VenueName" HeaderText="VenueName" SortExpression="VenueName" />
                        </Columns>
                    </asp:GridView>
                    <asp:ObjectDataSource ID="odsVenuesWithoutAddresses" runat="server" OldValuesParameterFormatString="original_{0}"
                        SelectMethod="SelectAllActiveWithOutAddress" SortParameterName="sortExpression"
                        TypeName="PlacementManager.VenueComponent">
                        <SelectParameters>
                            <asp:Parameter DefaultValue="VenueName" Name="sortExpression" Type="String" />
                        </SelectParameters>
                    </asp:ObjectDataSource>
                    <br />
                    The following Venues do not have a telephone number.<br />
                    <asp:GridView ID="gvVenuesWithoutTelephone" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" DataSourceID="odsVenuesWithoutTelephone" SkinID="Results">
                        <Columns>
                            <asp:BoundField DataField="VenueName" HeaderText="VenueName" SortExpression="VenueName" />
                        </Columns>
                    </asp:GridView>
                    <asp:ObjectDataSource ID="odsVenuesWithoutTelephone" runat="server" OldValuesParameterFormatString="original_{0}"
                        SelectMethod="SelectAllActiveWithoutTelephone" TypeName="PlacementManager.VenueComponent">
                        <SelectParameters>
                            <asp:Parameter DefaultValue="VenueName" Name="sortExpression" Type="String" />
                        </SelectParameters>
                    </asp:ObjectDataSource>
                    <br />
                </div>
                <div class="yui-u">
                    The following Venues are not associated with a category.<asp:GridView ID="gvVenuesWithoutCategories"
                        runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="odsVenuesWithoutCategories"
                        SkinID="Results">
                        <Columns>
                            <asp:BoundField DataField="VenueName" HeaderText="VenueName" SortExpression="VenueName" />
                        </Columns>
                    </asp:GridView>
                    <asp:ObjectDataSource ID="odsVenuesWithoutCategories" runat="server" DeleteMethod="Delete"
                        InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="SelectAllActiveWithoutCategory"
                        TypeName="PlacementManager.VenueComponent" UpdateMethod="Update">
                        <DeleteParameters>
                            <asp:Parameter Name="VenueId" Type="Int32" />
                        </DeleteParameters>
                        <SelectParameters>
                            <asp:Parameter DefaultValue="VenueName" Name="sortExpression" Type="String" />
                        </SelectParameters>
                    </asp:ObjectDataSource>
                    <br />
                    The following Venues are not associated with a Unit.
                    <asp:GridView ID="gvVenuesWithoutUnits" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                        DataSourceID="odsVenuesWithoutUnits" SkinID="Results">
                        <Columns>
                            <asp:BoundField DataField="VenueName" HeaderText="VenueName" SortExpression="VenueName" />
                        </Columns>
                    </asp:GridView>
                    <asp:ObjectDataSource ID="odsVenuesWithoutUnits" runat="server" DeleteMethod="Delete"
                        InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="SelectAllActiveWithoutUnit"
                        TypeName="PlacementManager.VenueComponent" UpdateMethod="Update">
                        <DeleteParameters>
                            <asp:Parameter Name="VenueId" Type="Int32" />
                        </DeleteParameters>
                        <SelectParameters>
                            <asp:Parameter DefaultValue="VenueName" Name="sortExpression" Type="String" />
                        </SelectParameters>
                    </asp:ObjectDataSource>
                    <br />
                </div>
            </div>
            </div>
            <div id="ft">
                Footer
            </div>
        </div>
        <!--Object Data Sources ************************************************* -->
    </form>
</body>
</html>
